﻿<%@ Page Title="" Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="ticket.aspx.vb" Inherits="str_ticket" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    
  

    <style type="text/css">
    .auto-style1 {
        height: 40px;
    }
</style>
    
  

</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
      <ContentTemplate>
          <asp:ScriptManager ID="ScriptManager1" runat="server">
           </asp:ScriptManager>
          
    <table style="width: 100%;">
        <tr>
            <td><h4>Ticket ID</h4></td>
            <td>
                <h4><asp:Label ID="Label1" runat="server" Text="Label"></asp:Label></h4>
            </td>
            <td>&nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td>Assigned Engineer</td>
            <td>
                <asp:DropDownList ID="listAssignedEngineer" runat="server" CssClass="textbox" DataSourceID="sqlEngrList" DataTextField="FullName" DataValueField="FullName" Width="275px">
                </asp:DropDownList>
                <asp:SqlDataSource ID="sqlEngrList" runat="server" ConnectionString="<%$ ConnectionStrings:Management_Info_SysConnectionString %>" SelectCommand="SELECT * FROM [user_info]"></asp:SqlDataSource>
            </td>
            <td>Status</td>
            <td>
                <asp:DropDownList ID="listStatus" runat="server" CssClass="textbox" Width="275px">
                    <asp:ListItem Selected="True">Open</asp:ListItem>
                    <asp:ListItem>Closed</asp:ListItem>
                </asp:DropDownList>
            </td>
        </tr>
        <tr>
            <td >Type</td>
            <td >
                <asp:DropDownList ID="listType" runat="server" CssClass="textbox" Width="275px">
                    <asp:ListItem>Choose</asp:ListItem>
                    <asp:ListItem>Problem Management</asp:ListItem>
                    <asp:ListItem>Incident</asp:ListItem>
                    <asp:ListItem>Service Request</asp:ListItem>
                </asp:DropDownList>
            </td>
            <td >&nbsp;</td>
            <td ></td>
        </tr>
        <tr>
            <td >&nbsp;</td>
            <td >&nbsp;</td>
            <td >&nbsp;</td>
            <td >&nbsp;</td>
        </tr>
        <tr>
            <td >Department</td>
            <td >
                <asp:DropDownList ID="listDepartment" runat="server" CssClass="textbox" DataSourceID="SqlCompany" DataTextField="company" DataValueField="company" AutoPostBack="True" Width="275px">
                </asp:DropDownList>
                <asp:SqlDataSource ID="SqlCompany" runat="server" ConnectionString="<%$ ConnectionStrings:Management_Info_SysConnectionString %>" SelectCommand="SELECT DISTINCT [company] FROM [stores]"></asp:SqlDataSource>
            </td>
            <td >Store</td>
            <td >
                <asp:DropDownList ID="listStore" runat="server" CssClass="textbox" DataSourceID="SqlStoreS" DataTextField="storename" DataValueField="storename" Width="275px">
                </asp:DropDownList>
                      <asp:SqlDataSource ID="SqlStoreS" runat="server" ConnectionString="<%$ ConnectionStrings:Management_Info_SysConnectionString %>" SelectCommand="SELECT [storename] FROM [stores] WHERE ([company] = @company)">
                          <SelectParameters>
                              <asp:ControlParameter ControlID="listDepartment" Name="company" PropertyName="SelectedValue" Type="String" />
                          </SelectParameters>
                      </asp:SqlDataSource>
            </td>
        </tr>
        <tr>
            <td >&nbsp;</td>
            <td >&nbsp;</td>
            <td >&nbsp;</td>
            <td >&nbsp;</td>
        </tr>
        <tr>
            <td>Creation Date</td>
            <td>
                <asp:TextBox ID="txtCreationDate" runat="server" CssClass="textbox" Width="275px" TextMode="Date"></asp:TextBox>
                <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="txtCreationDate" Display="None" ErrorMessage="* Creation Date"></asp:RequiredFieldValidator>
            </td>
            <td>Asset ID</td>
            <td>
                <asp:HyperLink ID="lableAssetID" runat="server">Click to Select From Asset List</asp:HyperLink>
            </td>
        </tr>
        <tr>
            <td>Category</td>
            <td>
                <asp:DropDownList ID="Listcategory" runat="server" CssClass="textbox" DataSourceID="sqlcategory" DataTextField="Category" DataValueField="Category" Width="275px">
                </asp:DropDownList>
                <asp:SqlDataSource ID="sqlcategory" runat="server" ConnectionString="<%$ ConnectionStrings:Management_Info_SysConnectionString %>" SelectCommand="SELECT [Category] FROM [ticket_category]"></asp:SqlDataSource>
            </td>
            <td>User</td>
            <td>
                <asp:TextBox ID="txtUser" runat="server" CssClass="textbox" Width="275px"></asp:TextBox>
                <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtUser" Display="None" ErrorMessage="* User"></asp:RequiredFieldValidator>
            </td>
        </tr>
        <tr>
            <td>Priority</td>
            <td>
                <asp:DropDownList ID="ListPriority" runat="server" CssClass="textbox" Width="275px">
                    <asp:ListItem Selected="True">Choose</asp:ListItem>
                    <asp:ListItem>High &gt; Affects Business</asp:ListItem>
                    <asp:ListItem>High &gt; Affects Group of Users</asp:ListItem>
                    <asp:ListItem>High &gt; Affects User</asp:ListItem>
                    <asp:ListItem>Medium &gt; Affects Business</asp:ListItem>
                    <asp:ListItem>Medium &gt; Affects Group of Users</asp:ListItem>
                    <asp:ListItem>Medium &gt; Affects User</asp:ListItem>
                    <asp:ListItem>Low &gt; Affects Business</asp:ListItem>
                </asp:DropDownList>
            </td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td>Subject</td>
            <td>
                <asp:TextBox ID="txtSubject" runat="server" CssClass="textbox" Width="275px"></asp:TextBox>
                <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="txtSubject" Display="None" ErrorMessage="* Subject"></asp:RequiredFieldValidator>
            </td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td style="vertical-align: top" >Description</td>
            <td >
                <asp:TextBox ID="txtDescription" runat="server" CssClass="multitextbox" TextMode="MultiLine" Width="275px"></asp:TextBox>
                <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="txtDescription" Display="None" ErrorMessage="* Description"></asp:RequiredFieldValidator>
            </td>
            <td style="vertical-align: top" >Resolution</td>
            <td >
                <asp:TextBox ID="txtResolution" runat="server" CssClass="multitextbox" TextMode="MultiLine" Width="275px"></asp:TextBox>
            </td>
        </tr>
        <tr>
            <td>Resolved By</td>
            <td>
                <asp:DropDownList ID="txtResolvedBy" runat="server" CssClass="textbox" DataSourceID="sqlEngrList" DataTextField="FullName" DataValueField="FullName" Width="275px">
                </asp:DropDownList>
            </td>
            <td>Resolved Date</td>
            <td>
                <asp:TextBox ID="txtResolvedDate" runat="server" CssClass="textbox" Width="275px" TextMode="Date"></asp:TextBox>
            </td>
        </tr>
        <tr>
            <td>Time to Resolve</td>
            <td>
                <asp:TextBox ID="txtTimeToResoved" runat="server" CssClass="textbox" Width="275px" TextMode="Time"></asp:TextBox>
                <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="txtTimeToResoved" Display="None" ErrorMessage="* Time to Resolve"></asp:RequiredFieldValidator>
            </td>
            <td>Source</td>
            <td>
                <asp:DropDownList ID="listSource" runat="server" CssClass="textbox" Width="275px">
                </asp:DropDownList>
                <asp:RequiredFieldValidator ID="RequiredFieldValidator7" runat="server" ControlToValidate="listSource" Display="None" ErrorMessage="* Source"></asp:RequiredFieldValidator>
            </td>
        </tr>
        <tr>
            <td>Client Name/User Name</td>
            <td>
                <asp:TextBox ID="txtUser_Name" runat="server" CssClass="textbox" Width="275px"></asp:TextBox>
                <asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ControlToValidate="txtUser_Name" Display="None" ErrorMessage="* Client Name/User Name"></asp:RequiredFieldValidator>
            </td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td class="auto-style1">
                <asp:Button ID="Button1" runat="server" Text="Add Ticket" Width="150px" CssClass="button" />
            </td>
            <td class="auto-style1"></td>
            <td class="auto-style1"></td>
            <td class="auto-style1"></td>
        </tr>
        <tr>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
        </tr>
    </table>
    <asp:SqlDataSource ID="TicketIDDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:Management_Info_SysConnectionString %>" SelectCommand="SELECT [Ticket_ID] FROM [ticket_items_mis] ORDER BY [T_ID] DESC"></asp:SqlDataSource>

    <asp:SqlDataSource ID="EngrList" runat="server" ConnectionString="<%$ ConnectionStrings:Management_Info_SysConnectionString %>" SelectCommand="SELECT [FullName] FROM [user_info] WHERE ([username] = @username)">
        <SelectParameters>
            <asp:SessionParameter Name="username" SessionField="AccountName" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
    </ContentTemplate>
        </asp:UpdatePanel>
</asp:Content>

